﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'MusicVideo') INSERT INTO MediaClass (Name) VALUES ('MusicVideo') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'PersonalVideo') INSERT INTO MediaClass (Name) VALUES ('PersonalVideo') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'PrivateVideo') INSERT INTO MediaClass (Name) VALUES ('PrivateVideo') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'TVRecording') INSERT INTO MediaClass (Name) VALUES ('TVRecording') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'OtherVideo') INSERT INTO MediaClass (Name) VALUES ('OtherVideo') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'Picture') INSERT INTO MediaClass (Name) VALUES ('Picture') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'PrivatePicture') INSERT INTO MediaClass (Name) VALUES ('PrivatePicture') 
IF NOT EXISTS (SELECT * FROM MediaClass WHERE Name = 'Music') INSERT INTO MediaClass (Name) VALUES ('Music')